Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 7959 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 754.1 KiB |
| Average record size in memory | 97.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 3 |
| Boolean | 1 |
isLastSmallPeriod has constant value "False" | Constant |
startDate has a high cardinality: 1698 distinct values | High cardinality |
endDate has a high cardinality: 1673 distinct values | High cardinality |
minDate has a high cardinality: 1560 distinct values | High cardinality |
df_index has unique values | Unique |
l_bias has unique values | Unique |
Reproduction
| Analysis started | 2021-01-10 15:13:08.501646 |
|---|---|
| Analysis finished | 2021-01-10 15:13:18.755232 |
| Duration | 10.25 seconds |
| Software version | pandas-profiling v2.10.0 |
| Download configuration | config.yaml |
| Distinct | 7959 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10437.68891 |
|---|---|
| Minimum | 0 |
| Maximum | 20998 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 62.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1041.9 |
| Q1 | 5116.5 |
| median | 10391 |
| Q3 | 15683 |
| 95-th percentile | 20013.1 |
| Maximum | 20998 |
| Range | 20998 |
| Interquartile range (IQR) | 10566.5 |
Descriptive statistics
| Standard deviation | 6101.733843 |
|---|---|
| Coefficient of variation (CV) | 0.5845866741 |
| Kurtosis | -1.216200541 |
| Mean | 10437.68891 |
| Median Absolute Deviation (MAD) | 5285 |
| Skewness | 0.01343791213 |
| Sum | 83073566 |
| Variance | 37231155.89 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 789 | 1 | < 0.1% |
| 13099 | 1 | < 0.1% |
| 18087 | 1 | < 0.1% |
| 9001 | 1 | < 0.1% |
| 11048 | 1 | < 0.1% |
| 19236 | 1 | < 0.1% |
| 13091 | 1 | < 0.1% |
| 15138 | 1 | < 0.1% |
| 4895 | 1 | < 0.1% |
| Other values (7949) | 7949 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 8 | 1 | |
| 10 | 1 | |
| 18 | 1 | |
| 23 | 1 |
| Value | Count | Frequency (%) |
| 20998 | 1 | |
| 20994 | 1 | |
| 20993 | 1 | |
| 20989 | 1 | |
| 20984 | 1 |
code
Real number (ℝ≥0)
| Distinct | 296 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 367889.7845 |
|---|---|
| Minimum | 1 |
| Maximum | 603993 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 538 |
| Q1 | 2271 |
| median | 600066 |
| Q3 | 600809 |
| 95-th percentile | 601919 |
| Maximum | 603993 |
| Range | 603992 |
| Interquartile range (IQR) | 598538 |
Descriptive statistics
| Standard deviation | 280916.49 |
|---|---|
| Coefficient of variation (CV) | 0.763588721 |
| Kurtosis | -1.707223803 |
| Mean | 367889.7845 |
| Median Absolute Deviation (MAD) | 1752 |
| Skewness | -0.4551044012 |
| Sum | 2928034795 |
| Variance | 7.891407438 × 1010 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) |
| 300015 | 60 | 0.8% |
| 600519 | 60 | 0.8% |
| 2050 | 60 | 0.8% |
| 2236 | 56 | 0.7% |
| 600674 | 55 | 0.7% |
| 2271 | 55 | 0.7% |
| 661 | 55 | 0.7% |
| 600809 | 55 | 0.7% |
| 2475 | 55 | 0.7% |
| 2311 | 54 | 0.7% |
| Other values (286) | 7394 |
| Value | Count | Frequency (%) |
| 1 | 25 | |
| 2 | 32 | |
| 63 | 44 | |
| 69 | 29 | |
| 100 | 35 |
| Value | Count | Frequency (%) |
| 603993 | 23 | |
| 603986 | 15 | |
| 603899 | 29 | |
| 603833 | 10 | 0.1% |
| 603799 | 16 |
lossRate
Real number (ℝ)
| Distinct | 7762 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.05721130744 |
|---|---|
| Minimum | -0.3984575835 |
| Maximum | -0.0001040907671 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.3 KiB |
Quantile statistics
| Minimum | -0.3984575835 |
|---|---|
| 5-th percentile | -0.1409787552 |
| Q1 | -0.07695414302 |
| median | -0.04684975767 |
| Q3 | -0.02641694786 |
| 95-th percentile | -0.00842167371 |
| Maximum | -0.0001040907671 |
| Range | 0.3983534928 |
| Interquartile range (IQR) | 0.05053719516 |
Descriptive statistics
| Standard deviation | 0.0431035406 |
|---|---|
| Coefficient of variation (CV) | -0.7534094662 |
| Kurtosis | 3.816888651 |
| Mean | -0.05721130744 |
| Median Absolute Deviation (MAD) | 0.02382864142 |
| Skewness | -1.544146049 |
| Sum | -455.3447959 |
| Variance | 0.001857915212 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| -0.06060606061 | 4 | 0.1% |
| -0.03846153846 | 4 | 0.1% |
| -0.05970149254 | 4 | 0.1% |
| -0.06666666667 | 4 | 0.1% |
| -0.02941176471 | 3 | < 0.1% |
| -0.08333333333 | 3 | < 0.1% |
| -0.02040816327 | 3 | < 0.1% |
| -0.04285714286 | 3 | < 0.1% |
| -0.03846153846 | 3 | < 0.1% |
| -0.1 | 3 | < 0.1% |
| Other values (7752) | 7925 |
| Value | Count | Frequency (%) |
| -0.3984575835 | 1 | |
| -0.3946203609 | 1 | |
| -0.3438377535 | 1 | |
| -0.3304014785 | 1 | |
| -0.3173719376 | 1 |
| Value | Count | Frequency (%) |
| -0.0001040907671 | 1 | |
| -0.0001629195178 | 1 | |
| -0.0002994908655 | 1 | |
| -0.0003404834866 | 1 | |
| -0.000357079093 | 1 |
| Distinct | 1698 |
|---|---|
| Distinct (%) | 21.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.3 KiB |
| 2019-02-25 | 56 |
|---|---|
| 2015-03-30 | 52 |
| 2014-12-08 | 46 |
| 2015-04-07 | 46 |
| 2015-03-23 | 41 |
| Other values (1693) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 79590 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 426 ? |
|---|---|
| Unique (%) | 5.4% |
Sample
| 1st row | 2011-05-03 |
|---|---|
| 2nd row | 2013-01-22 |
| 3rd row | 2013-02-01 |
| 4th row | 2014-07-03 |
| 5th row | 2014-11-11 |
| Value | Count | Frequency (%) |
| 2019-02-25 | 56 | 0.7% |
| 2015-03-30 | 52 | 0.7% |
| 2014-12-08 | 46 | 0.6% |
| 2015-04-07 | 46 | 0.6% |
| 2015-03-23 | 41 | 0.5% |
| 2015-05-26 | 38 | 0.5% |
| 2014-12-22 | 38 | 0.5% |
| 2015-04-13 | 34 | 0.4% |
| 2015-04-14 | 33 | 0.4% |
| 2014-08-04 | 32 | 0.4% |
| Other values (1688) | 7543 |
| Value | Count | Frequency (%) |
| 2019-02-25 | 56 | 0.7% |
| 2015-03-30 | 52 | 0.7% |
| 2014-12-08 | 46 | 0.6% |
| 2015-04-07 | 46 | 0.6% |
| 2015-03-23 | 41 | 0.5% |
| 2015-05-26 | 38 | 0.5% |
| 2014-12-22 | 38 | 0.5% |
| 2015-04-13 | 34 | 0.4% |
| 2015-04-14 | 33 | 0.4% |
| 2014-08-04 | 32 | 0.4% |
| Other values (1688) | 7543 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 18531 | |
| - | 15918 | |
| 1 | 14452 | |
| 2 | 13667 | |
| 4 | 2944 | 3.7% |
| 7 | 2690 | 3.4% |
| 3 | 2688 | 3.4% |
| 5 | 2561 | 3.2% |
| 9 | 2293 | 2.9% |
| 6 | 1993 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 63672 | |
| Dash Punctuation | 15918 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 18531 | |
| 1 | 14452 | |
| 2 | 13667 | |
| 4 | 2944 | 4.6% |
| 7 | 2690 | 4.2% |
| 3 | 2688 | 4.2% |
| 5 | 2561 | 4.0% |
| 9 | 2293 | 3.6% |
| 6 | 1993 | 3.1% |
| 8 | 1853 | 2.9% |
| Value | Count | Frequency (%) |
| - | 15918 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 79590 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 18531 | |
| - | 15918 | |
| 1 | 14452 | |
| 2 | 13667 | |
| 4 | 2944 | 3.7% |
| 7 | 2690 | 3.4% |
| 3 | 2688 | 3.4% |
| 5 | 2561 | 3.2% |
| 9 | 2293 | 2.9% |
| 6 | 1993 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79590 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 18531 | |
| - | 15918 | |
| 1 | 14452 | |
| 2 | 13667 | |
| 4 | 2944 | 3.7% |
| 7 | 2690 | 3.4% |
| 3 | 2688 | 3.4% |
| 5 | 2561 | 3.2% |
| 9 | 2293 | 2.9% |
| 6 | 1993 | 2.5% |
| Distinct | 1673 |
|---|---|
| Distinct (%) | 21.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.3 KiB |
| 2015-05-27 | 49 |
|---|---|
| 2015-04-07 | 43 |
| 2019-04-01 | 42 |
| 2019-02-25 | 42 |
| 2014-12-04 | 39 |
| Other values (1668) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 79590 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 422 ? |
|---|---|
| Unique (%) | 5.3% |
Sample
| 1st row | 2011-05-20 |
|---|---|
| 2nd row | 2013-01-29 |
| 3rd row | 2013-03-01 |
| 4th row | 2014-07-29 |
| 5th row | 2014-11-28 |
| Value | Count | Frequency (%) |
| 2015-05-27 | 49 | 0.6% |
| 2015-04-07 | 43 | 0.5% |
| 2019-04-01 | 42 | 0.5% |
| 2019-02-25 | 42 | 0.5% |
| 2014-12-04 | 39 | 0.5% |
| 2015-01-05 | 38 | 0.5% |
| 2015-05-26 | 36 | 0.5% |
| 2016-08-15 | 36 | 0.5% |
| 2015-04-08 | 35 | 0.4% |
| 2015-04-14 | 31 | 0.4% |
| Other values (1663) | 7568 |
| Value | Count | Frequency (%) |
| 2015-05-27 | 49 | 0.6% |
| 2015-04-07 | 43 | 0.5% |
| 2019-04-01 | 42 | 0.5% |
| 2019-02-25 | 42 | 0.5% |
| 2014-12-04 | 39 | 0.5% |
| 2015-01-05 | 38 | 0.5% |
| 2015-05-26 | 36 | 0.5% |
| 2016-08-15 | 36 | 0.5% |
| 2015-04-08 | 35 | 0.4% |
| 2015-04-14 | 31 | 0.4% |
| Other values (1663) | 7568 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 18728 | |
| - | 15918 | |
| 1 | 14347 | |
| 2 | 13529 | |
| 4 | 2870 | 3.6% |
| 5 | 2757 | 3.5% |
| 7 | 2600 | 3.3% |
| 3 | 2588 | 3.3% |
| 9 | 2386 | 3.0% |
| 6 | 1963 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 63672 | |
| Dash Punctuation | 15918 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 18728 | |
| 1 | 14347 | |
| 2 | 13529 | |
| 4 | 2870 | 4.5% |
| 5 | 2757 | 4.3% |
| 7 | 2600 | 4.1% |
| 3 | 2588 | 4.1% |
| 9 | 2386 | 3.7% |
| 6 | 1963 | 3.1% |
| 8 | 1904 | 3.0% |
| Value | Count | Frequency (%) |
| - | 15918 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 79590 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 18728 | |
| - | 15918 | |
| 1 | 14347 | |
| 2 | 13529 | |
| 4 | 2870 | 3.6% |
| 5 | 2757 | 3.5% |
| 7 | 2600 | 3.3% |
| 3 | 2588 | 3.3% |
| 9 | 2386 | 3.0% |
| 6 | 1963 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79590 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 18728 | |
| - | 15918 | |
| 1 | 14347 | |
| 2 | 13529 | |
| 4 | 2870 | 3.6% |
| 5 | 2757 | 3.5% |
| 7 | 2600 | 3.3% |
| 3 | 2588 | 3.3% |
| 9 | 2386 | 3.0% |
| 6 | 1963 | 2.5% |
| Distinct | 1560 |
|---|---|
| Distinct (%) | 19.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.3 KiB |
| 2015-05-07 | 76 |
|---|---|
| 2014-12-24 | 62 |
| 2014-08-28 | 61 |
| 2015-04-20 | 58 |
| 2014-09-22 | 52 |
| Other values (1555) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 79590 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 450 ? |
|---|---|
| Unique (%) | 5.7% |
Sample
| 1st row | 2011-05-16 |
|---|---|
| 2nd row | 2013-01-25 |
| 3rd row | 2013-02-22 |
| 4th row | 2014-07-21 |
| 5th row | 2014-11-18 |
| Value | Count | Frequency (%) |
| 2015-05-07 | 76 | 1.0% |
| 2014-12-24 | 62 | 0.8% |
| 2014-08-28 | 61 | 0.8% |
| 2015-04-20 | 58 | 0.7% |
| 2014-09-22 | 52 | 0.7% |
| 2014-12-09 | 51 | 0.6% |
| 2015-04-15 | 51 | 0.6% |
| 2019-03-28 | 49 | 0.6% |
| 2015-04-09 | 49 | 0.6% |
| 2019-03-08 | 47 | 0.6% |
| Other values (1550) | 7403 |
| Value | Count | Frequency (%) |
| 2015-05-07 | 76 | 1.0% |
| 2014-12-24 | 62 | 0.8% |
| 2014-08-28 | 61 | 0.8% |
| 2015-04-20 | 58 | 0.7% |
| 2014-09-22 | 52 | 0.7% |
| 2014-12-09 | 51 | 0.6% |
| 2015-04-15 | 51 | 0.6% |
| 2019-03-28 | 49 | 0.6% |
| 2015-04-09 | 49 | 0.6% |
| 2019-03-08 | 47 | 0.6% |
| Other values (1550) | 7403 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 18207 | |
| - | 15918 | |
| 1 | 14286 | |
| 2 | 13809 | |
| 7 | 2840 | 3.6% |
| 4 | 2702 | 3.4% |
| 3 | 2699 | 3.4% |
| 5 | 2608 | 3.3% |
| 9 | 2432 | 3.1% |
| 8 | 2078 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 63672 | |
| Dash Punctuation | 15918 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 18207 | |
| 1 | 14286 | |
| 2 | 13809 | |
| 7 | 2840 | 4.5% |
| 4 | 2702 | 4.2% |
| 3 | 2699 | 4.2% |
| 5 | 2608 | 4.1% |
| 9 | 2432 | 3.8% |
| 8 | 2078 | 3.3% |
| 6 | 2011 | 3.2% |
| Value | Count | Frequency (%) |
| - | 15918 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 79590 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 18207 | |
| - | 15918 | |
| 1 | 14286 | |
| 2 | 13809 | |
| 7 | 2840 | 3.6% |
| 4 | 2702 | 3.4% |
| 3 | 2699 | 3.4% |
| 5 | 2608 | 3.3% |
| 9 | 2432 | 3.1% |
| 8 | 2078 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79590 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 18207 | |
| - | 15918 | |
| 1 | 14286 | |
| 2 | 13809 | |
| 7 | 2840 | 3.6% |
| 4 | 2702 | 3.4% |
| 3 | 2699 | 3.4% |
| 5 | 2608 | 3.3% |
| 9 | 2432 | 3.1% |
| 8 | 2078 | 2.6% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 7959 |
smallPeriodDays
Real number (ℝ≥0)
| Distinct | 64 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.016585 |
|---|---|
| Minimum | 6 |
| Maximum | 82 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.3 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 7 |
| median | 10 |
| Q3 | 15 |
| 95-th percentile | 32 |
| Maximum | 82 |
| Range | 76 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 8.841983651 |
|---|---|
| Coefficient of variation (CV) | 0.6792859765 |
| Kurtosis | 6.272599062 |
| Mean | 13.016585 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 2.198417294 |
| Sum | 103599 |
| Variance | 78.18067489 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 1297 | |
| 7 | 1063 | |
| 8 | 849 | |
| 9 | 663 | 8.3% |
| 10 | 540 | 6.8% |
| 11 | 457 | 5.7% |
| 12 | 331 | 4.2% |
| 13 | 292 | 3.7% |
| 14 | 256 | 3.2% |
| 15 | 244 | 3.1% |
| Other values (54) | 1967 |
| Value | Count | Frequency (%) |
| 6 | 1297 | |
| 7 | 1063 | |
| 8 | 849 | |
| 9 | 663 | |
| 10 | 540 |
| Value | Count | Frequency (%) |
| 82 | 1 | |
| 78 | 2 | |
| 76 | 1 | |
| 75 | 1 | |
| 74 | 1 |
bigPeriodDays
Real number (ℝ≥0)
| Distinct | 225 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 108.6567408 |
|---|---|
| Minimum | 11 |
| Maximum | 363 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.3 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 34 |
| Q1 | 64 |
| median | 95 |
| Q3 | 140 |
| 95-th percentile | 232 |
| Maximum | 363 |
| Range | 352 |
| Interquartile range (IQR) | 76 |
Descriptive statistics
| Standard deviation | 62.05017287 |
|---|---|
| Coefficient of variation (CV) | 0.5710660233 |
| Kurtosis | 1.279586503 |
| Mean | 108.6567408 |
| Median Absolute Deviation (MAD) | 37 |
| Skewness | 1.131802088 |
| Sum | 864799 |
| Variance | 3850.223953 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 67 | 117 | 1.5% |
| 70 | 109 | 1.4% |
| 66 | 103 | 1.3% |
| 68 | 99 | 1.2% |
| 79 | 95 | 1.2% |
| 54 | 93 | 1.2% |
| 73 | 89 | 1.1% |
| 55 | 89 | 1.1% |
| 107 | 83 | 1.0% |
| 120 | 82 | 1.0% |
| Other values (215) | 7000 |
| Value | Count | Frequency (%) |
| 11 | 5 | 0.1% |
| 12 | 6 | |
| 13 | 12 | |
| 14 | 14 | |
| 15 | 9 |
| Value | Count | Frequency (%) |
| 363 | 20 | |
| 341 | 18 | |
| 332 | 21 | |
| 329 | 20 | |
| 274 | 35 |
riseRange
Real number (ℝ≥0)
| Distinct | 2471 |
|---|---|
| Distinct (%) | 31.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.397605931 |
|---|---|
| Minimum | 0.5118483412 |
| Maximum | 6.843658966 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.3 KiB |
Quantile statistics
| Minimum | 0.5118483412 |
|---|---|
| 5-th percentile | 0.8983473816 |
| Q1 | 1.02457956 |
| median | 1.189349112 |
| Q3 | 1.549192864 |
| 95-th percentile | 2.530394946 |
| Maximum | 6.843658966 |
| Range | 6.331810625 |
| Interquartile range (IQR) | 0.5246133042 |
Descriptive statistics
| Standard deviation | 0.6667616586 |
|---|---|
| Coefficient of variation (CV) | 0.4770741481 |
| Kurtosis | 21.95580931 |
| Mean | 1.397605931 |
| Median Absolute Deviation (MAD) | 0.2067837326 |
| Skewness | 3.884252296 |
| Sum | 11123.5456 |
| Variance | 0.4445711094 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 23 | 0.3% |
| 2.334225736 | 21 | 0.3% |
| 6.843658966 | 20 | 0.3% |
| 2.324515996 | 20 | 0.3% |
| 2.017815349 | 19 | 0.2% |
| 1.845789001 | 18 | 0.2% |
| 2.008610779 | 18 | 0.2% |
| 2.530394946 | 17 | 0.2% |
| 1.919002739 | 17 | 0.2% |
| 4.594441836 | 17 | 0.2% |
| Other values (2461) | 7769 |
| Value | Count | Frequency (%) |
| 0.5118483412 | 2 | |
| 0.5651372097 | 1 | |
| 0.5766419727 | 1 | |
| 0.6109682948 | 1 | |
| 0.6207565666 | 1 |
| Value | Count | Frequency (%) |
| 6.843658966 | 20 | |
| 6.766723014 | 7 | 0.1% |
| 5.620170801 | 5 | 0.1% |
| 5.349867976 | 13 | |
| 5.3290135 | 12 |
s_bias
Real number (ℝ)
| Distinct | 7958 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.102562336 |
|---|---|
| Minimum | -0.09284573052 |
| Maximum | 1.106707499 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.3 KiB |
Quantile statistics
| Minimum | -0.09284573052 |
|---|---|
| 5-th percentile | 0.01599387417 |
| Q1 | 0.052735814 |
| median | 0.084294713 |
| Q3 | 0.1304552862 |
| 95-th percentile | 0.248355741 |
| Maximum | 1.106707499 |
| Range | 1.199553229 |
| Interquartile range (IQR) | 0.07771947215 |
Descriptive statistics
| Standard deviation | 0.08221286288 |
|---|---|
| Coefficient of variation (CV) | 0.8015892194 |
| Kurtosis | 15.31099321 |
| Mean | 0.102562336 |
| Median Absolute Deviation (MAD) | 0.03682441578 |
| Skewness | 2.72368967 |
| Sum | 816.2936325 |
| Variance | 0.006758954823 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.05263157895 | 2 | < 0.1% |
| 0.1602891678 | 1 | < 0.1% |
| 0.1041920915 | 1 | < 0.1% |
| 0.04945599112 | 1 | < 0.1% |
| 0.07025707529 | 1 | < 0.1% |
| 0.1104420089 | 1 | < 0.1% |
| 0.1177748805 | 1 | < 0.1% |
| 0.08401300709 | 1 | < 0.1% |
| 0.166879298 | 1 | < 0.1% |
| 0.08309493713 | 1 | < 0.1% |
| Other values (7948) | 7948 |
| Value | Count | Frequency (%) |
| -0.09284573052 | 1 | |
| -0.07673089299 | 1 | |
| -0.0728923194 | 1 | |
| -0.06510034263 | 1 | |
| -0.06474820144 | 1 |
| Value | Count | Frequency (%) |
| 1.106707499 | 1 | |
| 1.016061165 | 1 | |
| 0.9373325698 | 1 | |
| 0.8773552587 | 1 | |
| 0.8624338624 | 1 |
m_bias
Real number (ℝ≥0)
| Distinct | 7958 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07910327637 |
|---|---|
| Minimum | 1.33226763 × 1015 |
| Maximum | 0.9684967843 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.3 KiB |
Quantile statistics
| Minimum | 1.33226763 × 1015 |
|---|---|
| 5-th percentile | 0.004440756383 |
| Q1 | 0.03109330823 |
| median | 0.06369837651 |
| Q3 | 0.1068745556 |
| 95-th percentile | 0.2044995751 |
| Maximum | 0.9684967843 |
| Range | 0.9684967843 |
| Interquartile range (IQR) | 0.07578124733 |
Descriptive statistics
| Standard deviation | 0.07022518631 |
|---|---|
| Coefficient of variation (CV) | 0.8877658364 |
| Kurtosis | 15.84828711 |
| Mean | 0.07910327637 |
| Median Absolute Deviation (MAD) | 0.03638174094 |
| Skewness | 2.607508576 |
| Sum | 629.5829767 |
| Variance | 0.004931576792 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.33226763 × 1015 | 2 | < 0.1% |
| 0.04954463447 | 1 | < 0.1% |
| 0.014943376 | 1 | < 0.1% |
| 0.01403454382 | 1 | < 0.1% |
| 0.3177959703 | 1 | < 0.1% |
| 0.07797642087 | 1 | < 0.1% |
| 0.1746770026 | 1 | < 0.1% |
| 0.03708387393 | 1 | < 0.1% |
| 0.07780040733 | 1 | < 0.1% |
| 0.001395746355 | 1 | < 0.1% |
| Other values (7948) | 7948 |
| Value | Count | Frequency (%) |
| 1.33226763 × 1015 | 2 | |
| 2.457998943 × 105 | 1 | |
| 2.709219474 × 105 | 1 | |
| 3.381051237 × 105 | 1 | |
| 5.329993204 × 105 | 1 |
| Value | Count | Frequency (%) |
| 0.9684967843 | 1 | |
| 0.9465185753 | 1 | |
| 0.8779733772 | 1 | |
| 0.834602934 | 1 | |
| 0.7098167787 | 1 |
| Distinct | 7959 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06394346155 |
|---|---|
| Minimum | 8.881784197 × 1016 |
| Maximum | 0.6681156445 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.3 KiB |
Quantile statistics
| Minimum | 8.881784197 × 1016 |
|---|---|
| 5-th percentile | 0.00217332084 |
| Q1 | 0.01894001911 |
| median | 0.04842025859 |
| Q3 | 0.09021202116 |
| 95-th percentile | 0.1810652068 |
| Maximum | 0.6681156445 |
| Range | 0.6681156445 |
| Interquartile range (IQR) | 0.07127200205 |
Descriptive statistics
| Standard deviation | 0.06036180163 |
|---|---|
| Coefficient of variation (CV) | 0.9439870812 |
| Kurtosis | 6.086380221 |
| Mean | 0.06394346155 |
| Median Absolute Deviation (MAD) | 0.03350406097 |
| Skewness | 1.867215775 |
| Sum | 508.9260105 |
| Variance | 0.003643547097 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.08950569514 | 1 | < 0.1% |
| 0.01821796196 | 1 | < 0.1% |
| 0.0005867937794 | 1 | < 0.1% |
| 0.004983047083 | 1 | < 0.1% |
| 0.1326325507 | 1 | < 0.1% |
| 0.05491637705 | 1 | < 0.1% |
| 0.02024615647 | 1 | < 0.1% |
| 0.04603049854 | 1 | < 0.1% |
| 0.05457651994 | 1 | < 0.1% |
| 0.1288258333 | 1 | < 0.1% |
| Other values (7949) | 7949 |
| Value | Count | Frequency (%) |
| 8.881784197 × 1016 | 1 | |
| 1.33226763 × 1015 | 1 | |
| 1.318768025 × 106 | 1 | |
| 3.147732532 × 106 | 1 | |
| 7.887741661 × 106 | 1 |
| Value | Count | Frequency (%) |
| 0.6681156445 | 1 | |
| 0.583336402 | 1 | |
| 0.5002695031 | 1 | |
| 0.4655514956 | 1 | |
| 0.4554244311 | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | code | lossRate | startDate | endDate | minDate | isLastSmallPeriod | smallPeriodDays | bigPeriodDays | riseRange | s_bias | m_bias | l_bias | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 1 | -0.058727 | 2011-05-03 | 2011-05-20 | 2011-05-16 | False | 10 | 27 | 0.876509 | 0.017394 | 0.077776 | 0.002700 |
| 1 | 8 | 1 | -0.064941 | 2013-01-22 | 2013-01-29 | 2013-01-25 | False | 6 | 59 | 1.064736 | 0.233735 | 0.138455 | 0.022700 |
| 2 | 10 | 1 | -0.147570 | 2013-02-01 | 2013-03-01 | 2013-02-22 | False | 16 | 59 | 1.064736 | 0.198504 | 0.201464 | 0.063554 |
| 3 | 18 | 1 | -0.041165 | 2014-07-03 | 2014-07-29 | 2014-07-21 | False | 18 | 70 | 1.044012 | 0.015170 | 0.041356 | 0.011473 |
| 4 | 23 | 1 | -0.058563 | 2014-11-11 | 2014-11-28 | 2014-11-18 | False | 14 | 69 | 1.278643 | 0.072567 | 0.011601 | 0.025239 |
| 5 | 26 | 1 | -0.108339 | 2014-12-08 | 2014-12-17 | 2014-12-15 | False | 8 | 69 | 1.278643 | 0.286698 | 0.091743 | 0.031115 |
| 6 | 27 | 1 | -0.083984 | 2014-12-17 | 2015-01-05 | 2014-12-24 | False | 12 | 69 | 1.278643 | 0.184408 | 0.148926 | 0.048943 |
| 7 | 31 | 1 | -0.010025 | 2015-04-01 | 2015-04-13 | 2015-04-02 | False | 8 | 65 | 1.118075 | 0.070171 | 0.026983 | 0.098919 |
| 8 | 33 | 1 | -0.107059 | 2015-04-16 | 2015-06-08 | 2015-05-18 | False | 37 | 65 | 1.118075 | 0.216236 | 0.124301 | 0.082291 |
| 9 | 37 | 1 | -0.007946 | 2016-07-04 | 2016-07-13 | 2016-07-08 | False | 8 | 64 | 1.035187 | 0.020999 | 0.000687 | 0.008565 |
Last rows
| df_index | code | lossRate | startDate | endDate | minDate | isLastSmallPeriod | smallPeriodDays | bigPeriodDays | riseRange | s_bias | m_bias | l_bias | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7949 | 20968 | 603993 | -0.130782 | 2015-05-27 | 2015-06-05 | 2015-05-29 | False | 8 | 151 | 1.486559 | 0.099149 | 0.099388 | 0.180459 |
| 7950 | 20977 | 603993 | -0.010526 | 2017-02-16 | 2017-02-23 | 2017-02-17 | False | 6 | 55 | 1.014613 | 0.151376 | 0.027309 | 0.012395 |
| 7951 | 20980 | 603993 | -0.043393 | 2017-07-03 | 2017-07-10 | 2017-07-04 | False | 6 | 88 | 1.424797 | 0.080217 | 0.037798 | 0.007462 |
| 7952 | 20981 | 603993 | -0.082949 | 2017-07-10 | 2017-07-19 | 2017-07-13 | False | 8 | 88 | 1.424797 | 0.285799 | 0.106190 | 0.001975 |
| 7953 | 20983 | 603993 | -0.103261 | 2017-07-21 | 2017-08-03 | 2017-07-27 | False | 10 | 88 | 1.424797 | 0.256080 | 0.203537 | 0.020847 |
| 7954 | 20984 | 603993 | -0.180723 | 2017-08-03 | 2017-08-31 | 2017-08-18 | False | 21 | 88 | 1.424797 | 0.102014 | 0.283564 | 0.056603 |
| 7955 | 20989 | 603993 | -0.070000 | 2018-03-05 | 2018-03-13 | 2018-03-08 | False | 7 | 39 | 0.914918 | 0.185068 | 0.038754 | 0.006990 |
| 7956 | 20993 | 603993 | -0.020619 | 2019-03-11 | 2019-03-18 | 2019-03-14 | False | 6 | 39 | 0.818557 | 0.055151 | 0.111160 | 0.001857 |
| 7957 | 20994 | 603993 | -0.094949 | 2019-03-18 | 2019-04-02 | 2019-03-27 | False | 12 | 39 | 0.818557 | 0.040025 | 0.132945 | 0.012879 |
| 7958 | 20998 | 603993 | -0.212314 | 2020-01-14 | 2020-02-14 | 2020-02-03 | False | 18 | 43 | 0.848416 | 0.114265 | 0.125749 | 0.011199 |